Tabela Visit

Definicja tabeli Visit

Name

Visit

Code

Visit

Comment

 


Lista kolumn tabeli Visit

Name

Code

VisitID

VisitID

VisitTypeID

VisitTypeID

ReservationID

ReservationID

ReferralID

ReferralID

PersonID

PersonID

EventID

EventID

VisitSourceID

VisitSourceID

VisitStatusID

VisitStatusID

ContinuationOfTreatmentID

ContinuationOfTreatmentID

Comments

Comments

Econfirmation

Econfirmation

UUID

UUID

HoursToRemind

HoursToRemind

VisitDT

VisitDT


Kolumna VisitID tabeli Visit

Definicja kolumny VisitID tabeli Visit

Name

VisitID

Code

VisitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VisitTypeID tabeli Visit

Definicja kolumny VisitTypeID tabeli Visit

Name

VisitTypeID

Code

VisitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReservationID tabeli Visit

Definicja kolumny ReservationID tabeli Visit

Name

ReservationID

Code

ReservationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReferralID tabeli Visit

Definicja kolumny ReferralID tabeli Visit

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli Visit

Definicja kolumny PersonID tabeli Visit

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli Visit

Definicja kolumny EventID tabeli Visit

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VisitSourceID tabeli Visit

Definicja kolumny VisitSourceID tabeli Visit

Name

VisitSourceID

Code

VisitSourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID sposobu dokonania wizyty


Kolumna VisitStatusID tabeli Visit

Definicja kolumny VisitStatusID tabeli Visit

Name

VisitStatusID

Code

VisitStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContinuationOfTreatmentID tabeli Visit

Definicja kolumny ContinuationOfTreatmentID tabeli Visit

Name

ContinuationOfTreatmentID

Code

ContinuationOfTreatmentID

Data Type

NUMBER(10)

Mandatory

No

Comment

Sposób kontynuacji leczenia


Kolumna Comments tabeli Visit

Definicja kolumny Comments tabeli Visit

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Econfirmation tabeli Visit

Definicja kolumny Econfirmation tabeli Visit

Name

Econfirmation

Code

Econfirmation

Data Type

NUMBER(1)

Mandatory

No

Comment

 


Kolumna UUID tabeli Visit

Definicja kolumny UUID tabeli Visit

Name

UUID

Code

UUID

Data Type

VARCHAR2(36)

Mandatory

No

Comment

 


Kolumna HoursToRemind tabeli Visit

Definicja kolumny HoursToRemind tabeli Visit

Name

HoursToRemind

Code

HoursToRemind

Data Type

NUMBER(10)

Mandatory

No

Comment

Informacja ile godzin przed wizyta ma byc wyslane przypomnienie


Kolumna VisitDT tabeli Visit

Definicja kolumny VisitDT tabeli Visit

Name

VisitDT

Code

VisitDT

Data Type

DATE

Mandatory

No

Comment

Kolumna przechowuje informacje o dacie faktycznego przybycia pacjenta (dializy
otrzewnowe).


Lista kluczy tabeli Visit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Visit

Definicja klucza Identifier_1 tabeli Visit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment